<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link href="site.css" rel="stylesheet" type="text/css" />
</head>

<body>
	<div id="content">
		<cfparam name="lsh" default="0" type="integer">
		<cfset lsh = 5>
		<cfset landon = 1>
		<cfloop index="loopcount" from="1" to="#lsh#">
			This is loop number	<cfoutput>#landon#</cfoutput><br />
			<cfset landon = landon+1>
		</cfloop>	
		<br />
		<CFQUERY name="qParts" datasource="LSH">
		SELECT PART_NO, PRICE_A FROM INVENTORY_LSH
		WHERE PART_NO like 'MAS-2U-%' AND LOCATION='000'
		</CFQUERY>
				<table>
					<tr>
						<th>Part</th>
						<th>Price</th>
						<th>Qty</th>
					</tr>	
					<cfform action="form_action.cfm">
						<CFLOOP query="qParts">
							<tr>
								<cfoutput>
								<td>#part_no#</td>
								<td>#DollarFormat(price_a)#</td>
								<td><input type="text" name="P#part_no#_QTY" /></td>
								</cfoutput>								
							</tr>
						</CFLOOP>		
						<tr>
							<td><input type="submit" /></td>
						</tr>	
					</cfform>					
					</table>
	</div>
</body>
</html>